{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["LEASE RENEWAL WORKSHEET","Features and Amenties","Rent Comparison"],"not_rendered":{"images":2,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"LEASE RENEWAL WORKSHEET","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"hidden":true,"merged":[[0,0,0,15]]}
["LEASE RENEWAL WORKSHEET"]
[]
["Apt #","Lease Expiration Date","Floorplan","Current Rent","Current Utilities","Current Garage","Current Storage","Current Pet","Market Rent","Proposed Rent","Proposed Utilities","Proposed Garage","Proposed Storage","Proposed Pet","Net Rental Increase","Comments"]
[101,"2009-10-31","a1",{"v":500,"d":"$500.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":600,"d":"$600.00"},{"v":550,"d":"$550.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$f":"J4-D4","v":{"v":50,"d":"$50.00"}},"Example"]
[{"$nulls":14},{"$f":"J5-D5","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}]
[{"$nulls":14},{"v":0,"d":"$0.00"}," "]

{"sheet":"Features and Amenties","index":1,"n_rows":73,"n_cols":8,"rows_kept":73,"merged":[[1,1,3,1],[1,3,3,6]]}
[]
[null,"2020-02-15",null,"Monthly Market Survey"]
[]
[]
[]
[{"$nulls":3},"Subject Property Picture / Logo","Comp 1 Picture / Logo","Comp 2 Picture / Logo","Comp 3 Picture / Logo","Comp 3 Picture / Logo"]
[null,"SITE NAMES:",null,"Your Property's Name","Comp 1","Comp 2","Comp 3","Comp 4"]
[]
[null,"General"]
[null,"Phone Number"]
[null,"Address"]
[null,"City, State Zip"]
[null,"Total Number of Units"]
[null,"Year Built"]
[null,"Year Rehab"]
[null,"Percent Occupied"]
[null,"Management Company"]
[null,"Special/Concession"]
[]
[null,"Specifics"]
[null,"Lease Terms Offered"]
[null,"Security Deposit Amount"]
[null,"Application Fee/ Admin Fee "]
[null,"Pets Accepted Yes/No"]
[null,"Pet Deposit / Pet Rent"]
[null,"In-House Corp Suites"]
[]
[null,"Utilities"]
[null,"Water & Sewer Incl. "]
[null,"Garbage Incl."]
[null,"Cable Ready"]
[null,"Electric Sub-metered"]
[]
[null,"Interior Features"]
[null,"Washer/Dryer Hook-ups"]
[null,"Washer/Dryer Provided"]
[null,"Ceiling Fans"]
[null,"Dishwasher"]
[null,"Garbage Disposal"]
[null,"Microwave"]
[null,"Icemaker"]
[null,"Intrusion Alarms"]
[null,"Extra Storage Space"]
[null,"Blinds Or Drapes"]
[]
[null,"Exterior Amenities"]
[null,"Laundry Room"]
[null,"Tennis/Basketball"]
[null,"Gated/Controlled Access"]
[null,"Fitness Center"]
[null,"Pool"]
[null,"Jacuzzi"]
[null,"Sauna"]
[null,"Clubhouse"]
[null,"Conf Room/Busn Center"]
[null,"Playground"]
[null,"Dog Park"]
[null,"Business Center"]
[null,"Covered Parking Avail/Price"]
[null,"Extra Storage Avail/Price"]
[]
[null,"Services  Offered"]
[null,"24 Hour On Call Maint"]
[null,"Pest Control"]
[null,"Courtesy Patrol"]
[]
[null,"Ratings (Exc. Avg. Poor)"]
[null,"Close To Shopping"]
[null,"General Location"]
[null,"Landscaping"]
[null,"Office Staff"]
[null,"Apt. Interior Appearance"]
[null,"Building Appearance"]

{"sheet":"Rent Comparison","index":2,"n_rows":69,"n_cols":7,"rows_kept":69,"merged":[[1,0,3,0],[5,1,5,5],[6,1,6,5],[7,1,7,5],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[63,5,63,6],[64,5,64,6],[65,5,65,6],[66,5,66,6],[67,5,67,6],[68,5,68,6]]}
[]
[{"$f":"'Features and Amenties'!B2","v":"2020-02-15"}]
[]
[]
[]
["Property",{"$f":"'Features and Amenties'!D7","v":"Your Property's Name"}]
["Date",{"$f":"A2","v":"2020-02-15"}]
["Prepared By"]
[]
["PROPERTY NAME","PHONE #",null,"YEAR BUILT","YEAR REHAB","TOTAL UNITS","OCCUPANCY %"]
[{"$f":"'Features and Amenties'!D7","v":"Your Property's Name"},{"$f":"'Features and Amenties'!D10","v":0},null,{"$f":"'Features and Amenties'!D14","v":0},{"$f":"'Features and Amenties'!D15","v":0},{"$f":"'Features and Amenties'!D13","v":0},{"$f":"'Features and Amenties'!D16","v":{"v":0,"d":"0%"}}]
[{"$f":"'Features and Amenties'!E7","v":"Comp 1"},{"$f":"'Features and Amenties'!E10","v":0},null,{"$f":"'Features and Amenties'!E14","v":0},{"$f":"'Features and Amenties'!E15","v":0},{"$f":"'Features and Amenties'!E13","v":0},{"$f":"'Features and Amenties'!E16","v":{"v":0,"d":"0%"}}]
[{"$f":"'Features and Amenties'!F7","v":"Comp 2"},{"$f":"'Features and Amenties'!F10","v":0},null,{"$f":"'Features and Amenties'!F14","v":0},{"$f":"'Features and Amenties'!F15","v":0},{"$f":"'Features and Amenties'!F13","v":0},{"$f":"'Features and Amenties'!F16","v":{"v":0,"d":"0%"}}]
[{"$f":"'Features and Amenties'!G7","v":"Comp 3"},{"$f":"'Features and Amenties'!G10","v":0},null,{"$f":"'Features and Amenties'!G14","v":0},{"$f":"'Features and Amenties'!G15","v":0},{"$f":"'Features and Amenties'!G13","v":0},{"$f":"'Features and Amenties'!G16","v":{"v":0,"d":"0%"}}]
[{"$f":"'Features and Amenties'!H7","v":"Comp 4"},{"$f":"'Features and Amenties'!H10","v":0},null,{"$f":"'Features and Amenties'!H14","v":0},{"$f":"'Features and Amenties'!H15","v":0},{"$f":"'Features and Amenties'!H13","v":0},{"$f":"'Features and Amenties'!H16","v":{"v":0,"d":"0%"}}]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A11","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C17-D17)/B17","v":{"$error":"#DIV/0!"}},{"$f":"(C17-D17)","v":0}]
[{"$f":"A12","v":"Comp 1"},null,0,0,{"$f":"SUM(C18-D18)/B18","v":{"$error":"#DIV/0!"}},{"$f":"(C18-D18)","v":0}]
[{"$f":"A13","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A14","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A15","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A17","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C23-D23)/B23","v":{"$error":"#DIV/0!"}},{"$f":"(C23-D23)","v":0}]
[{"$f":"A18","v":"Comp 1"},null,0,0,{"$f":"SUM(C24-D24)/B24","v":{"$error":"#DIV/0!"}},{"$f":"(C24-D24)","v":0}]
[{"$f":"A19","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A20","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A21","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A23","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C29-D29)/B29","v":{"$error":"#DIV/0!"}},{"$f":"(C29-D29)","v":0}]
[{"$f":"A24","v":"Comp 1"},null,0,0,{"$f":"SUM(C30-D30)/B30","v":{"$error":"#DIV/0!"}},{"$f":"(C30-D30)","v":0}]
[{"$f":"A25","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A26","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A27","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A29","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C35-D35)/B35","v":{"$error":"#DIV/0!"}},{"$f":"(C35-D35)","v":0}]
[{"$f":"A30","v":"Comp 1"},null,0,0,{"$f":"SUM(C36-D36)/B36","v":{"$error":"#DIV/0!"}},{"$f":"(C36-D36)","v":0}]
[{"$f":"A31","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A32","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A33","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A35","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C41-D41)/B41","v":{"$error":"#DIV/0!"}},{"$f":"(C41-D41)","v":0}]
[{"$f":"A36","v":"Comp 1"},null,0,0,{"$f":"SUM(C42-D42)/B42","v":{"$error":"#DIV/0!"}},{"$f":"(C42-D42)","v":0}]
[{"$f":"A37","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A38","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A39","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A41","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C47-D47)/B47","v":{"$error":"#DIV/0!"}},{"$f":"(C47-D47)","v":0}]
[{"$f":"A42","v":"Comp 1"},null,0,0,{"$f":"SUM(C48-D48)/B48","v":{"$error":"#DIV/0!"}},{"$f":"(C48-D48)","v":0}]
[{"$f":"A43","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A44","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A45","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A47","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C53-D53)/B53","v":{"$error":"#DIV/0!"}},{"$f":"(C53-D53)","v":0}]
[{"$f":"A48","v":"Comp 1"},null,0,0,{"$f":"SUM(C54-D54)/B54","v":{"$error":"#DIV/0!"}},{"$f":"(C54-D54)","v":0}]
[{"$f":"A49","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A50","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A51","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A53","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C59-D59)/B59","v":{"$error":"#DIV/0!"}},{"$f":"(C59-D59)","v":0}]
[{"$f":"A54","v":"Comp 1"},null,0,0,{"$f":"SUM(C60-D60)/B60","v":{"$error":"#DIV/0!"}},{"$f":"(C60-D60)","v":0}]
[{"$f":"A55","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A56","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A57","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]
["Floor Plan Name","SF","MARKET RENT","MONTHLY CONC","RENT/SF","NET EFFECTIVE RENT"]
[{"$f":"A59","v":"Your Property's Name"},null,0,0,{"$f":"SUM(C65-D65)/B65","v":{"$error":"#DIV/0!"}},{"$f":"(C65-D65)","v":0}]
[{"$f":"A60","v":"Comp 1"},null,0,0,{"$f":"SUM(C66-D66)/B66","v":{"$error":"#DIV/0!"}},{"$f":"(C66-D66)","v":0}]
[{"$f":"A61","v":"Comp 2"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A62","v":"Comp 3"},null,0,0,{"$error":"#DIV/0!"},0]
[{"$f":"A63","v":"Comp 4"},null,0,0,{"$error":"#DIV/0!"},0]